<!DOCTYPE html>
<html lang="en">
<head>
  <title>SchemaCrawler Output</title>
  <meta charset="utf-8"/>
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"/>
  <style>

body, p, li, td, th, caption, select, input, strong {
  font-family: "Century Gothic", CenturyGothic, Geneva, sans-serif;
  font-size: 1rem;
  line-height: 1.4rem;
  color: rgb(16, 16, 16);
}

body {
  margin: 1rem 3rem;
}

code, pre, tt {
  font-family: 'Lucida Console', Monaco, 'Courier New', monospace;
  font-size: 1rem;
  line-height: 1.4rem;
  color: rgb(16, 16, 16);
}

hr {
  height: 1px;
  border-width: 1px 0 0 0;
  color: silver;
}

p {
  margin-bottom: 0.5rem;
}

caption {
  border-bottom: 2px solid black;
  padding: 2px 5px;
  text-align: left;
}

h1, h2, h3 {
  font-family: "Palatino Linotype", Georgia, "Times New Roman", serif;
  margin-top: 1rem;
  margin-bottom: 1.5rem;
  font-weight: bold;
}

h1 {
  font-size: 1.6rem;
  line-height: 1.8rem;
}

h2 {
  font-size: 1.4rem;
  line-height: 1.6rem;
}

h3 {
  font-size: 1.2rem;
  line-height: 1.4rem;
}

dl, ul, ol {
  border: 0;
  background-color: #fff;
  margin-left: 1rem;
  padding: 0 0 0 1rem;
}

li {
  margin-top: 0.3rem;
}

table, th, td {
  border: 1px solid rgb(240, 240, 240);
  border-collapse: collapse;
  vertical-align: top;
  padding: 2px;
}

table {
  width: 800px;
  max-width: 1000px;
  min-width: 600px;
}

th {
  font-weight: bold;
  border-bottom: 1px solid rgb(190, 190, 190);
}

blockquote {
  background: #f9f9f9;
  margin: 5px;
  border-left: 10px solid #ccc;
  padding: 0.5rem 10px;
}

blockquote:before {
  color: #ccc;
  font-size: 4rem;
  line-height: 0.1rem;
  margin-right: 0.25rem;
  vertical-align: -0.4rem;
}

blockquote p {
  display: inline;
  background: #f9f9f9;
}

h1 {
  color: maroon;
}

h2 {
  color: darkblue;
}

h3 {
  color: green;
}

a:link, a:visited {
  color: rgb(123, 42, 144);
  text-decoration: none;
}

a:hover, a:active {
  color: rgb(123, 42, 144);
  background-color: rgb(255, 255, 180);
  text-decoration: none;
  border-bottom: 1px solid rgb(123, 42, 144);
  border-radius: 3px;
}

.caption_name {
  font-weight: bold;
  font-style: italic;
}

.caption_description {
  float: right;
}

.name {
  font-weight: bold;
  min-width: 350px;
}

.property_name {
  min-width: 350px;
}

.property_value {
  min-width: 250px;
}

.right {
  text-align: right;
}

.description {
  min-width: 450px;
}

.spacer {
  min-width: 20px;
}

.minwidth {
  min-width: 150px;
}

.definition {
  word-break: normal;
  word-wrap: break-word;
  white-space: pre;
  white-space: -moz-pre-wrap;
  white-space: pre-wrap;
  white-space: pre\9;

  font-family: 'Lucida Console', Monaco, 'Courier New', monospace;
  font-size: 1rem;
  font-weight: 100;

  line-height: 1.2rem;
  color: rgb(16, 16, 16);
}

.remarks {
  word-break: normal;
  word-wrap: break-word;
  white-space: pre;
  white-space: -moz-pre-wrap;
  white-space: pre-wrap;
  white-space: pre\9;
}

td:nth-of-type(1) {
  width: 30px;
}

td.section {
  font-family: "Palatino Linotype", Georgia, "Times New Roman", serif;
  padding-top: 1.5rem;
  padding-bottom: 1rem;
  font-weight: bold;
  font-size: 1.2rem;
  line-height: 1.2rem;
  color: rgb(100, 100, 100);
}

.data_binary {
  font-style: italic;
  color: rgb(64, 64, 64);
}

.data_null {
  font-style: italic;
  color: rgb(64, 64, 64);
  background-color: rgb(240, 240, 240);
}

.data_number {
  text-align: right;
  padding-right: 5px;
}


  </style>
</head>
<body>

<p>&#160;</p>
<h2>Tables</h2>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='authors_f521e766' class='caption_name'>PUBLIC.BOOKS.AUTHORS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Contact details for book authors</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>FIRSTNAME</td>
		<td class='minwidth'>VARCHAR(20) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>LASTNAME</td>
		<td class='minwidth'>VARCHAR(20) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>CITY</td>
		<td class='minwidth'>VARCHAR(50)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>STATE</td>
		<td class='minwidth'>CHARACTER(2)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>VARCHAR(10)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>VARCHAR(50)</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth'>default 'USA'</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_AUTHORS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>Z_FK_AUTHOR</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#bookauthors_ead84c5d'>PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='authorslist_9ccb3c04' class='caption_name'>PUBLIC.BOOKS.AUTHORSLIST</span>
		<span class='caption_description'>[view]</span>
	</caption>

</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='bookauthors_ead84c5d' class='caption_name'>PUBLIC.BOOKS.BOOKAUTHORS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Relationship between books and their authors, 
along with the latest updated information</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID</td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>Z_FK_AUTHOR</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>AUTHORID (0..many)→ <a href='#authors_f521e766'>PUBLIC.BOOKS.AUTHORS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10118</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID (0..many)→ <a href='#books_f4a675c8'>PUBLIC.BOOKS.BOOKS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='books_f4a675c8' class='caption_name'>PUBLIC.BOOKS.BOOKS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>Details for published books</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Unique (internal) id for book</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>PREVIOUSEDITIONID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_BOOKS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_BOOK</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.BOOKID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10118</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#bookauthors_ead84c5d'>PUBLIC.BOOKS.BOOKAUTHORS.BOOKID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_PREVIOUSEDITION</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..1) <a href='#books_f4a675c8'>PREVIOUSEDITIONID</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='celebrities_db1258df' class='caption_name'>PUBLIC.BOOKS."Celebrities"</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>"Id"</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>"PK_Celebrities"</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Id"</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10128</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Id" ←(0..1) <a href='#celebrityupdates_f5088e8b'>PUBLIC.BOOKS."Celebrity Updates"."Celebrity Id"</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='celebrityupdates_f5088e8b' class='caption_name'>PUBLIC.BOOKS."Celebrity Updates"</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>"Celebrity Id"</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>"PK Celebrity Updates"</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id"</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_FK_10128</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>"Celebrity Id" (0..1)→ <a href='#celebrities_db1258df'>PUBLIC.BOOKS."Celebrities"."Id"</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='coupons_54c3042b' class='caption_name'>PUBLIC.BOOKS.COUPONS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_COUPONS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='customerdata_b0af83c6' class='caption_name'>PUBLIC.BOOKS.CUSTOMERDATA</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERDATA</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='customers_f705d773' class='caption_name'>PUBLIC.BOOKS.CUSTOMERS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='publishers_8037d535' class='caption_name'>PUBLIC.BOOKS.PUBLISHERS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td colspan='3' class='remarks'>List of book publishers</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ID</i></b></td>
		<td class='minwidth'>INTEGER NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth'>auto-incremented</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'></td>
		<td class='minwidth remarks'>Unique (internal) id for book publisher</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>SYS_PK_10124</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_ΒΙΒΛΊΑ_PUBLISHERS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ID ←(0..many) <a href='#βιβλία_3cecb755'>PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #FFFF00;'>
		<span id='βιβλία_3cecb755' class='caption_name'>PUBLIC.BOOKS.ΒΙΒΛΊΑ</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>ΜΟΝΑΔΙΚΌΣ</i></b></td>
		<td class='minwidth'>SMALLINT NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΕΚΔΌΤΗΣ</td>
		<td class='minwidth'>SMALLINT NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_ΒΙΒΛΊΑ</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΜΟΝΑΔΙΚΌΣ</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_ΒΙΒΛΊΑ_PUBLISHERS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>ΕΚΔΌΤΗΣ (0..many)→ <a href='#publishers_8037d535'>PUBLIC.BOOKS.PUBLISHERS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #9900CC;'>
		<span id='regions_dbf65bbf' class='caption_name'>PUBLIC."PUBLISHER SALES".REGIONS</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>POSTALCODE</i></b></td>
		<td class='minwidth'>VARCHAR(10) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'><b><i>COUNTRY</i></b></td>
		<td class='minwidth'>VARCHAR(50) NOT NULL</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Primary Key</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>PK_CUSTOMERS</td>
		<td class='description right'>[primary key]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_REGIONS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.POSTALCODE</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.COUNTRY</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #9900CC;'>
		<span id='sales_751e68cc' class='caption_name'>PUBLIC."PUBLISHER SALES".SALES</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE</td>
		<td class='minwidth'>VARCHAR(10) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY</td>
		<td class='minwidth'>VARCHAR(50) NOT NULL</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_BOOK</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>BOOKID (0..many)→ <a href='#books_f4a675c8'>PUBLIC.BOOKS.BOOKS.ID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_SALESDATA</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID (0..many)→ <a href='#salesdata_1193fa76'>PUBLIC."PUBLISHER SALES".SALESDATA.SALESDATAID</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_REGIONS</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>POSTALCODE (0..many)→ <a href='#regions_dbf65bbf'>PUBLIC."PUBLISHER SALES".REGIONS.POSTALCODE</a></td>
		<td class='minwidth'></td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>COUNTRY (0..many)→ <a href='#regions_dbf65bbf'>PUBLIC."PUBLISHER SALES".REGIONS.COUNTRY</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>



<table>
	<caption style='background-color: #9900CC;'>
		<span id='salesdata_1193fa76' class='caption_name'>PUBLIC."PUBLISHER SALES".SALESDATA</span>
		<span class='caption_description'>[table]</span>
	</caption>

	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID</td>
		<td class='minwidth'>INTEGER</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='3' class='section'>Foreign Keys</td>
	</tr>
	<tr>
		<td colspan='3'></td>
	</tr>
	<tr>
		<td colspan='2' class='name'>FK_SALES_SALESDATA</td>
		<td class='description right'>[foreign key, with no action]</td>
	</tr>
	<tr>
		<td class='spacer'></td>
		<td class='minwidth'>SALESDATAID ←(0..many) <a href='#sales_751e68cc'>PUBLIC."PUBLISHER SALES".SALES.SALESDATAID</a></td>
		<td class='minwidth'></td>
	</tr>
</table>
<p>&#160;</p>

</body>
</html>
